Macro variables created with the Parameter Manager might not resolve as expected when used with the %LET to create a new macro variable in a code node. The Parameter Manager uses the %NRSTR macro quoting function by default when creating parameters with a type of String. This function masks special characters in the string and wraps the value with delta characters. These delta characters cause what appears to be a space when creating a new macro variable using the %LET in a code node, so the new variable does not resolve properly.

For example, we create the macro variables TABLE and SUFFIX in the Parameter Manager. When we create a new macro variable in the code node that is a concatenation of the results of these macro values (OUTTABLE) and resolve it on the DATA statement, it creates two output datasets: MYTABLE_ and TMP. The expected result is one output dataset called MYTABLE_TMP.

%LET outputtable = &table._&suffix;

data &outputtable;
   set sashelp.class;
run;

A workaround is to use the %UNQUOTE macro function when resolving the macro variable:

%LET outputtable = &table._&suffix;

data %UNQUOTE(&outputtable);
   set sashelp.class;
run;

Operating System and Release Information